Microsoft Excel Q/a Practice Questions Answers Test With Solutions & More Shortcuts

Question : 1

Which is not an advantage of using computerized spread sheets?

a) flexibility of moving entries

b) speed of calculation

c) ability of generate tables

d) cost of initial setup

e) None of these

Question : 2

Which language is used to create macros in Excel?

a) Visual Basic 4

b) C

c) Visual C++

d) Java

e) None of these

Question : 3

How do you display current date and time In MS Excel?

a) date( )

b) Today ( )

c) now( )

d) time( )

e) None of these

Question : 4

Which function calculates your monthly mortage payment?

a) PMT (payments)

b) NPER (number of periods)

c) PV (present value)

d) All of above

e) None of these

Question : 5

The minimum and maximum value you can set for Save AutoRecovery Info in Excel are

a) 1 and 120 minutes

b) O and 120 minutes

c) 2 and 60 minutes

d) 1 and 10 minutes

e) None of these